# scores/models.py
from sqlalchemy import Column, String, Integer
from ..database import Base


class Score(Base):
    __tablename__ = "scores"

    student_id = Column(String(20), primary_key=True, comment="学生编号")
    student_name = Column(String(20), nullable=True, comment="学生姓名")
    class_name = Column(String(20), nullable=True, comment="学生班级")
    exam_sequence = Column(Integer, primary_key=True, nullable=False, comment='考核序次')
    score = Column(Integer, nullable=True, comment='分数')